SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwtAreasExterioresPredio
AS
SELECT     dbo.u_f1_06_areasexteriores.Id, dbo.u_f1_06_areasexteriores.idCui, dbo.u_f1_06_areasexteriores.numIdentific, 
                      dbo.u_tp_terminacionpiso.descripcion AS TipoArea, dbo.u_tp_areas_exteriores.descripcion AS TerminacionPiso, 
                      dbo.u_tp_estado.descripcion AS Estado
FROM         dbo.u_f1_06_areasexteriores LEFT OUTER JOIN
                      dbo.u_f1_00_varios ON dbo.u_f1_06_areasexteriores.idCui = dbo.u_f1_00_varios.idCui LEFT OUTER JOIN
                      dbo.u_tp_estado ON dbo.u_f1_06_areasexteriores.idEstado = dbo.u_tp_estado.Id LEFT OUTER JOIN
                      dbo.u_tp_areas_exteriores ON dbo.u_f1_06_areasexteriores.idTipoAreaExterior = dbo.u_tp_areas_exteriores.Id LEFT OUTER JOIN
                      dbo.u_tp_terminacionpiso ON dbo.u_f1_06_areasexteriores.idTermPiso = dbo.u_tp_terminacionpiso.id
GO
GRANT SELECT ON  [dbo].[vwtAreasExterioresPredio] TO [Cenie]
GO
